<?php
//======================================================================================
//
// Function: Connect to a database
//
// NOTE: config.php must have been include before you include this!
//
// Programmer: JKJ
// Date      : 2022-01-06
//
// ------------------------------------------------------------------------------------------
// One year since the crazy fvcking Trump supporters tried to overcome US democracy.
// FVCK TRUMP AND ALL HIS SUPPORTERS AND DF AND NY BOGERLIGE AND ALL RIGHT WING SHITHEADS!!!!
// ------------------------------------------------------------------------------------------
//
// Copyright Reeft A/S (c) - 2021
//======================================================================================

	if ( $DFT_DATABASE_TO_USE == '*MYSQL') {

		//include "include/web-connect-mysql.php";
		
		$hostname = 'localhost';
		$username = 'admin';
		$password = 'costello';
		$database = 'reeft_db';

		try {
			$file_db = new PDO("mysql:host=$hostname;dbname=$database;charset=utf8mb4", $username, $password);
			// Set the PDO error mode to exception
			$file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			//$file_db->set_charset('utf8mb4');
			//echo "Connected successfully"; 
		} catch (PDOException $e) {
			echo "Connection failed: " . $e->getMessage();
		}		

	}
	else if ( $DFT_DATABASE_TO_USE == '*MARIA_DB') {

		
		$hostname 	= '127.0.0.1';
		$username 	= 'admin';
		$password 	= 'costello';
		$database 	= 'reeft_db';
		$port 		= '3307';

		try {
			$file_db = new PDO("mysql:host=$hostname;dbname=$database;port=$port;charset=utf8mb4", $username, $password);
			// Set the PDO error mode to exception
			$file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			//$file_db->set_charset('utf8mb4');
			//echo "Connected successfully"; 
		} catch (PDOException $e) {
			echo "Connection failed: " . $e->getMessage();
		}		

	}
	else if ( $DFT_DATABASE_TO_USE == '*PGSQL') {

		
		$hostname = 'localhost';
		$username = 'postgres';
		$password = 'costello';
		$database = 'reeft_db';

		try {
			$file_db = new PDO("pgsql:host=$hostname;dbname=$database;user=$username;password=$password");			
			// Set the PDO error mode to exception
			$file_db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			//$file_db->set_charset('utf8mb4');
			//echo "Connected successfully"; 
		} catch (PDOException $e) {
			echo "Connection failed: " . $e->getMessage();
		}		

	}
	else
	{

		$DFT_SQLLITE_IP = $DFT_SQLLITE_IP;

		// Conncetion is found in /config/config.php
		$file_db = new PDO("sqlite:$DFT_SQLLITE_IP");

		// Set errormode to exceptions
		$file_db->setAttribute(PDO::ATTR_ERRMODE,
							   PDO::ERRMODE_EXCEPTION);


	}


?>